//	Ordinaire.Database.DbConvert
//	Copyright (c) 2008 Jonathan Loe
//
//	MIT license (http://en.wikipedia.org/wiki/MIT_License)
//
//	Permission is hereby granted, free of charge, to any person obtaining a copy
//	of this software and associated documentation files (the "Software"), to deal
//	in the Software without restriction, including without limitation the rights 
//	to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies
//	of the Software, and to permit persons to whom the Software is furnished to do so, 
//	subject to the following conditions:
//
//	The above copyright notice and this permission notice shall be included in all 
//	copies or substantial portions of the Software.
//
//	THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, 
//	INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR
//	PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE 
//	FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
//	ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

using System;
using System.Collections.Generic;
using System.Text;

namespace Ordinaire.Database
{
	/// <summary>
	/// DbConvert is an extension of System.Convert static class to handle System.DBNull.
	/// </summary>
	public class DbConvert
	{
		/// <summary>
		/// Converts System.Object to boolean.
		/// </summary>
		/// <param name="value">value</param>
		/// <returns>returns false if value is of DBNull type.</returns>
		public static bool ToBoolean(object value)
		{
			if (value is DBNull) return false;
			return Convert.ToBoolean(value);
		}

		/// <summary>
		/// Converts System.Object to int.
		/// </summary>
		/// <param name="value">value</param>
		/// <returns>returns 0 if value is of DBNull type.</returns>
		public static int ToInt32(object value)
		{
			if (value is DBNull) return 0;
			return Convert.ToInt32(value);
		}

		/// <summary>
		/// Converts System.Object to decimal.
		/// </summary>
		/// <param name="value">value</param>
		/// <returns>returns 0 if value is of DBNull type.</returns>
		public static decimal ToDecimal(object value)
		{
			if (value is DBNull) return (decimal)0;
			return Convert.ToDecimal(value);
		}

		/// <summary>
		/// Convert System.Object to string.
		/// </summary>
		/// <param name="value">value</param>
		/// <returns>returns String.Empty if value is of DBNull type.</returns>
		public static String ToString(object value)
		{
			if (value is DBNull) return String.Empty;
			return Convert.ToString(value);
		}

		/// <summary>
		/// Converts System.Object to System.DateTime
		/// </summary>
		/// <param name="value">value</param>
		/// <returns>returns DateTime.Ticks = 0 if value is of DBNull type.</returns>
		public static DateTime ToDateTime(object value)
		{
			if (value is DBNull) return new DateTime();
			return Convert.ToDateTime(value);
		}
	}
}
